Dataset statistics
| Number of variables | 24 |
|---|---|
| Number of observations | 13644 |
| Missing cells | 67159 |
| Missing cells (%) | 20.5% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 3.1 MiB |
| Average record size in memory | 241.0 B |
Variable types
| NUM | 12 |
|---|---|
| CAT | 11 |
| BOOL | 1 |
Reproduction
| Analysis started | 2020-06-03 05:46:12.258482 |
|---|---|
| Analysis finished | 2020-06-03 05:47:18.854152 |
| Duration | 1 minute and 6.6 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
state has constant value "WA" | Constant |
propertyName has a high cardinality: 697 distinct values | High cardinality |
street has a high cardinality: 697 distinct values | High cardinality |
neighborhood has a high cardinality: 87 distinct values | High cardinality |
unit has a high cardinality: 1726 distinct values | High cardinality |
name has a high cardinality: 4476 distinct values | High cardinality |
rent has 4132 (30.3%) missing values | Missing |
sqft has 213 (1.6%) missing values | Missing |
deposit has 13452 (98.6%) missing values | Missing |
unit has 9113 (66.8%) missing values | Missing |
leaseLength has 13480 (98.8%) missing values | Missing |
name has 335 (2.5%) missing values | Missing |
new has 13121 (96.2%) missing values | Missing |
applyNow has 13309 (97.5%) missing values | Missing |
Unnamed: 0_x has 178 (1.3%) zeros | Zeros |
reviewScore has 9224 (67.6%) zeros | Zeros |
reviewCount has 5516 (40.4%) zeros | Zeros |
transitScore has 212 (1.6%) zeros | Zeros |
| Distinct count | 752 |
|---|---|
| Unique (%) | 5.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 239.02059513339196 |
|---|---|
| Minimum | 0 |
| Maximum | 751 |
| Zeros | 178 |
| Zeros (%) | 1.3% |
| Memory size | 106.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 58 |
| median | 161 |
| Q3 | 365.25 |
| 95-th percentile | 711 |
| Maximum | 751 |
| Range | 751 |
| Interquartile range (IQR) | 307.25 |
Descriptive statistics
| Standard deviation | 223.0319473 |
|---|---|
| Coefficient of variation (CV) | 0.9331076562 |
| Kurtosis | -0.2335259764 |
| Mean | 239.0205951 |
| Median Absolute Deviation (MAD) | 119 |
| Skewness | 0.982545378 |
| Sum | 3261197 |
| Variance | 49743.24952 |
| Value | Count | Frequency (%) | |
| 67 | 220 | 1.6% | |
| 734 | 220 | 1.6% | |
| 61 | 200 | 1.5% | |
| 699 | 200 | 1.5% | |
| 0 | 178 | 1.3% | |
| 362 | 178 | 1.3% | |
| 57 | 158 | 1.2% | |
| 676 | 158 | 1.2% | |
| 6 | 157 | 1.2% | |
| 63 | 148 | 1.1% | |
| Other values (742) | 11827 | 86.7% |
| Value | Count | Frequency (%) | |
| 0 | 178 | 1.3% | |
| 1 | 40 | 0.3% | |
| 2 | 68 | 0.5% | |
| 3 | 26 | 0.2% | |
| 4 | 54 | 0.4% |
| Value | Count | Frequency (%) | |
| 751 | 8 | 0.1% | |
| 750 | 48 | 0.4% | |
| 749 | 6 | < 0.1% | |
| 748 | 8 | 0.1% | |
| 747 | 12 | 0.1% |
| Distinct count | 697 |
|---|---|
| Unique (%) | 5.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 106.6 KiB |
| Batik | 440 |
|---|---|
| Alexan 100 | 400 |
| Jackson Apartments | 356 |
| 624 Yale | 316 |
| Sedona Apartments | 296 |
| Other values (692) |
| Value | Count | Frequency (%) | |
| Batik | 440 | 3.2% | |
| Alexan 100 | 400 | 2.9% | |
| Jackson Apartments | 356 | 2.6% | |
| 624 Yale | 316 | 2.3% | |
| Sedona Apartments | 296 | 2.2% | |
| Assembly118 | 288 | 2.1% | |
| Met Tower | 272 | 2.0% | |
| STAZIONE25 | 264 | 1.9% | |
| Saxton | 252 | 1.8% | |
| McKenzie | 176 | 1.3% | |
| Other values (687) | 10584 | 77.6% |
Length
| Max length | 45 |
|---|---|
| Median length | 11 |
| Mean length | 12.62943418 |
| Min length | 2 |
| Distinct count | 697 |
|---|---|
| Unique (%) | 5.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 106.6 KiB |
| 123 Broadway | 440 |
|---|---|
| 100 Denny Way | 400 |
| 2401 S Jackson St | 356 |
| 624 Yale Ave N | 316 |
| 8500 20th Ave NE | 296 |
| Other values (692) |
| Value | Count | Frequency (%) | |
| 123 Broadway | 440 | 3.2% | |
| 100 Denny Way | 400 | 2.9% | |
| 2401 S Jackson St | 356 | 2.6% | |
| 624 Yale Ave N | 316 | 2.3% | |
| 8500 20th Ave NE | 296 | 2.2% | |
| 4200 S Othello St | 288 | 2.1% | |
| 1942-1942 Westlake Ave | 272 | 2.0% | |
| 2615 25th Ave S | 264 | 1.9% | |
| 520 Terry Ave | 252 | 1.8% | |
| 2202 Eighth Ave | 176 | 1.3% | |
| Other values (687) | 10584 | 77.6% |
Length
| Max length | 38 |
|---|---|
| Median length | 15 |
| Mean length | 15.57248607 |
| Min length | 10 |
city
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 106.6 KiB |
| Seattle | |
|---|---|
| Lake Forest Park | 26 |
| Burien | 11 |
| Shoreline | 4 |
| Value | Count | Frequency (%) | |
| Seattle | 13603 | 99.7% | |
| Lake Forest Park | 26 | 0.2% | |
| Burien | 11 | 0.1% | |
| Shoreline | 4 | < 0.1% |
Length
| Max length | 16 |
|---|---|
| Median length | 7 |
| Mean length | 7.016930519 |
| Min length | 6 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 106.6 KiB |
| WA |
|---|
| Value | Count | Frequency (%) | |
| WA | 13644 | 100.0% |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
zipCode
Real number (ℝ≥0)
| Distinct count | 32 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 98116.88199941366 |
|---|---|
| Minimum | 98101 |
| Maximum | 98199 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 106.6 KiB |
Quantile statistics
| Minimum | 98101 |
|---|---|
| 5-th percentile | 98101 |
| Q1 | 98108 |
| median | 98115 |
| Q3 | 98122 |
| 95-th percentile | 98144 |
| Maximum | 98199 |
| Range | 98 |
| Interquartile range (IQR) | 14 |
Descriptive statistics
| Standard deviation | 14.62209843 |
|---|---|
| Coefficient of variation (CV) | 0.0001490273451 |
| Kurtosis | 8.608362182 |
| Mean | 98116.882 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 2.369625893 |
| Sum | 1338706738 |
| Variance | 213.8057626 |
| Value | Count | Frequency (%) | |
| 98109 | 2482 | 18.2% | |
| 98122 | 1471 | 10.8% | |
| 98121 | 1463 | 10.7% | |
| 98101 | 1021 | 7.5% | |
| 98115 | 954 | 7.0% | |
| 98144 | 737 | 5.4% | |
| 98116 | 718 | 5.3% | |
| 98104 | 705 | 5.2% | |
| 98125 | 705 | 5.2% | |
| 98107 | 518 | 3.8% | |
| Other values (22) | 2870 | 21.0% |
| Value | Count | Frequency (%) | |
| 98101 | 1021 | 7.5% | |
| 98102 | 159 | 1.2% | |
| 98103 | 505 | 3.7% | |
| 98104 | 705 | 5.2% | |
| 98105 | 344 | 2.5% |
| Value | Count | Frequency (%) | |
| 98199 | 58 | 0.4% | |
| 98198 | 15 | 0.1% | |
| 98188 | 85 | 0.6% | |
| 98178 | 25 | 0.2% | |
| 98177 | 1 | < 0.1% |
| Distinct count | 87 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Memory size | 106.6 KiB |
| South Lake Union | 1611 |
|---|---|
| First Hill | 1074 |
| Belltown | 993 |
| Denny Triangle | 956 |
| Lower Queen Anne | 840 |
| Other values (82) |
| Value | Count | Frequency (%) | |
| South Lake Union | 1611 | 11.8% | |
| First Hill | 1074 | 7.9% | |
| Belltown | 993 | 7.3% | |
| Denny Triangle | 956 | 7.0% | |
| Lower Queen Anne | 840 | 6.2% | |
| Capitol Hill | 737 | 5.4% | |
| Ballard | 490 | 3.6% | |
| Atlantic | 425 | 3.1% | |
| Brighton | 356 | 2.6% | |
| Roosevelt | 350 | 2.6% | |
| Other values (77) | 5808 | 42.6% |
Length
| Max length | 31 |
|---|---|
| Median length | 10 |
| Mean length | 11.57292583 |
| Min length | 3 |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.5583406625622984 |
|---|---|
| Minimum | 0 |
| Maximum | 5 |
| Zeros | 9224 |
| Zeros (%) | 67.6% |
| Memory size | 106.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 5 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 2.264788044 |
|---|---|
| Coefficient of variation (CV) | 1.453333086 |
| Kurtosis | -1.351812219 |
| Mean | 1.558340663 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.7846450508 |
| Sum | 21262 |
| Variance | 5.129264885 |
| Value | Count | Frequency (%) | |
| 0 | 9224 | 67.6% | |
| 5 | 3641 | 26.7% | |
| 4 | 738 | 5.4% | |
| 3 | 23 | 0.2% | |
| 2 | 18 | 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 9224 | 67.6% | |
| 2 | 18 | 0.1% | |
| 3 | 23 | 0.2% | |
| 4 | 738 | 5.4% | |
| 5 | 3641 | 26.7% |
| Value | Count | Frequency (%) | |
| 5 | 3641 | 26.7% | |
| 4 | 738 | 5.4% | |
| 3 | 23 | 0.2% | |
| 2 | 18 | 0.1% | |
| 0 | 9224 | 67.6% |
| Distinct count | 24 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.4695836997947818 |
|---|---|
| Minimum | 0 |
| Maximum | 150 |
| Zeros | 5516 |
| Zeros (%) | 40.4% |
| Memory size | 106.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 4 |
| 95-th percentile | 15 |
| Maximum | 150 |
| Range | 150 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 7.751634553 |
|---|---|
| Coefficient of variation (CV) | 2.234168484 |
| Kurtosis | 139.4384503 |
| Mean | 3.4695837 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 9.025237986 |
| Sum | 47339 |
| Variance | 60.08783825 |
| Value | Count | Frequency (%) | |
| 0 | 5516 | 40.4% | |
| 1 | 2201 | 16.1% | |
| 2 | 1165 | 8.5% | |
| 5 | 941 | 6.9% | |
| 3 | 884 | 6.5% | |
| 4 | 720 | 5.3% | |
| 6 | 336 | 2.5% | |
| 8 | 284 | 2.1% | |
| 15 | 261 | 1.9% | |
| 23 | 199 | 1.5% | |
| Other values (14) | 1137 | 8.3% |
| Value | Count | Frequency (%) | |
| 0 | 5516 | 40.4% | |
| 1 | 2201 | 16.1% | |
| 2 | 1165 | 8.5% | |
| 3 | 884 | 6.5% | |
| 4 | 720 | 5.3% |
| Value | Count | Frequency (%) | |
| 150 | 14 | 0.1% | |
| 53 | 83 | 0.6% | |
| 24 | 84 | 0.6% | |
| 23 | 199 | 1.5% | |
| 22 | 13 | 0.1% |
walkScore
Real number (ℝ≥0)
| Distinct count | 75 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 90.7982996188801 |
|---|---|
| Minimum | 9 |
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 106.6 KiB |
Quantile statistics
| Minimum | 9 |
|---|---|
| 5-th percentile | 69 |
| Q1 | 90 |
| median | 96 |
| Q3 | 98 |
| 95-th percentile | 99 |
| Maximum | 100 |
| Range | 91 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 12.17441151 |
|---|---|
| Coefficient of variation (CV) | 0.1340819328 |
| Kurtosis | 7.132671395 |
| Mean | 90.79829962 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -2.507152451 |
| Sum | 1238852 |
| Variance | 148.2162956 |
| Value | Count | Frequency (%) | |
| 99 | 2285 | 16.7% | |
| 98 | 1438 | 10.5% | |
| 97 | 1366 | 10.0% | |
| 96 | 1106 | 8.1% | |
| 95 | 787 | 5.8% | |
| 92 | 695 | 5.1% | |
| 90 | 681 | 5.0% | |
| 100 | 672 | 4.9% | |
| 93 | 580 | 4.3% | |
| 89 | 389 | 2.9% | |
| Other values (65) | 3645 | 26.7% |
| Value | Count | Frequency (%) | |
| 9 | 1 | < 0.1% | |
| 10 | 1 | < 0.1% | |
| 16 | 1 | < 0.1% | |
| 19 | 1 | < 0.1% | |
| 20 | 6 | < 0.1% |
| Value | Count | Frequency (%) | |
| 100 | 672 | 4.9% | |
| 99 | 2285 | 16.7% | |
| 98 | 1438 | 10.5% | |
| 97 | 1366 | 10.0% | |
| 96 | 1106 | 8.1% |
| Distinct count | 67 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 77.04954558780416 |
|---|---|
| Minimum | 0 |
| Maximum | 100 |
| Zeros | 212 |
| Zeros (%) | 1.6% |
| Memory size | 106.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 50 |
| Q1 | 59 |
| median | 82 |
| Q3 | 100 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 41 |
Descriptive statistics
| Standard deviation | 20.85972055 |
|---|---|
| Coefficient of variation (CV) | 0.2707312599 |
| Kurtosis | 0.8524035019 |
| Mean | 77.04954559 |
| Median Absolute Deviation (MAD) | 18 |
| Skewness | -0.7662133003 |
| Sum | 1051264 |
| Variance | 435.1279416 |
| Value | Count | Frequency (%) | |
| 100 | 3923 | 28.8% | |
| 54 | 758 | 5.6% | |
| 82 | 602 | 4.4% | |
| 59 | 541 | 4.0% | |
| 66 | 474 | 3.5% | |
| 56 | 442 | 3.2% | |
| 70 | 437 | 3.2% | |
| 52 | 407 | 3.0% | |
| 64 | 405 | 3.0% | |
| 84 | 385 | 2.8% | |
| Other values (57) | 5270 | 38.6% |
| Value | Count | Frequency (%) | |
| 0 | 212 | 1.6% | |
| 33 | 4 | < 0.1% | |
| 34 | 1 | < 0.1% | |
| 35 | 8 | 0.1% | |
| 36 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 100 | 3923 | 28.8% | |
| 99 | 73 | 0.5% | |
| 98 | 9 | 0.1% | |
| 97 | 99 | 0.7% | |
| 96 | 72 | 0.5% |
Unnamed: 0_y
Real number (ℝ≥0)
| Distinct count | 10762 |
|---|---|
| Unique (%) | 78.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5480.078789211375 |
|---|---|
| Minimum | 0 |
| Maximum | 10761 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Memory size | 106.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 462 |
| Q1 | 2532 |
| median | 5383.5 |
| Q3 | 8705.25 |
| 95-th percentile | 10408.85 |
| Maximum | 10761 |
| Range | 10761 |
| Interquartile range (IQR) | 6173.25 |
Descriptive statistics
| Standard deviation | 3352.311984 |
|---|---|
| Coefficient of variation (CV) | 0.6117269684 |
| Kurtosis | -1.368434903 |
| Mean | 5480.078789 |
| Median Absolute Deviation (MAD) | 3056.5 |
| Skewness | 0.0159681242 |
| Sum | 74770195 |
| Variance | 11237995.64 |
| Value | Count | Frequency (%) | |
| 0 | 2 | < 0.1% | |
| 10547 | 2 | < 0.1% | |
| 10587 | 2 | < 0.1% | |
| 8824 | 2 | < 0.1% | |
| 2640 | 2 | < 0.1% | |
| 2685 | 2 | < 0.1% | |
| 10579 | 2 | < 0.1% | |
| 9606 | 2 | < 0.1% | |
| 8832 | 2 | < 0.1% | |
| 2648 | 2 | < 0.1% | |
| Other values (10752) | 13624 | 99.9% |
| Value | Count | Frequency (%) | |
| 0 | 2 | < 0.1% | |
| 1 | 2 | < 0.1% | |
| 2 | 2 | < 0.1% | |
| 3 | 2 | < 0.1% | |
| 4 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 10761 | 2 | < 0.1% | |
| 10760 | 2 | < 0.1% | |
| 10759 | 2 | < 0.1% | |
| 10758 | 2 | < 0.1% | |
| 10757 | 2 | < 0.1% |
bedRoomType
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 106.6 KiB |
| Traditional | |
|---|---|
| Studio |
| Value | Count | Frequency (%) | |
| Traditional | 10842 | 79.5% | |
| Studio | 2802 | 20.5% |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 9.973175022 |
| Min length | 6 |
bedRoomNumber
Real number (ℝ≥0)
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.2837144532395193 |
|---|---|
| Minimum | 1 |
| Maximum | 6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 106.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 6 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.5061189284 |
|---|---|
| Coefficient of variation (CV) | 0.3942612994 |
| Kurtosis | 4.173943486 |
| Mean | 1.283714453 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.786197531 |
| Sum | 17515 |
| Variance | 0.2561563697 |
| Value | Count | Frequency (%) | |
| 1 | 10081 | 73.9% | |
| 2 | 3295 | 24.1% | |
| 3 | 239 | 1.8% | |
| 4 | 20 | 0.1% | |
| 5 | 7 | 0.1% | |
| 6 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 10081 | 73.9% | |
| 2 | 3295 | 24.1% | |
| 3 | 239 | 1.8% | |
| 4 | 20 | 0.1% | |
| 5 | 7 | 0.1% |
| Value | Count | Frequency (%) | |
| 6 | 2 | < 0.1% | |
| 5 | 7 | 0.1% | |
| 4 | 20 | 0.1% | |
| 3 | 239 | 1.8% | |
| 2 | 3295 | 24.1% |
baths
Real number (ℝ≥0)
| Distinct count | 12 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.227792436235708 |
|---|---|
| Minimum | 0.0 |
| Maximum | 5.0 |
| Zeros | 17 |
| Zeros (%) | 0.1% |
| Memory size | 106.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.4417549202 |
|---|---|
| Coefficient of variation (CV) | 0.3597960919 |
| Kurtosis | 2.331313893 |
| Mean | 1.227792436 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.660588025 |
| Sum | 16752 |
| Variance | 0.1951474095 |
| Value | Count | Frequency (%) | |
| 1 | 10517 | 77.1% | |
| 2 | 2701 | 19.8% | |
| 1.5 | 243 | 1.8% | |
| 2.5 | 81 | 0.6% | |
| 3 | 53 | 0.4% | |
| 3.5 | 25 | 0.2% | |
| 0 | 17 | 0.1% | |
| 0.5 | 2 | < 0.1% | |
| 4 | 2 | < 0.1% | |
| 3.25 | 1 | < 0.1% | |
| Other values (2) | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 17 | 0.1% | |
| 0.5 | 2 | < 0.1% | |
| 1 | 10517 | 77.1% | |
| 1.5 | 243 | 1.8% | |
| 2 | 2701 | 19.8% |
| Value | Count | Frequency (%) | |
| 5 | 1 | < 0.1% | |
| 4 | 2 | < 0.1% | |
| 3.5 | 25 | 0.2% | |
| 3.25 | 1 | < 0.1% | |
| 3 | 53 | 0.4% |
| Distinct count | 1846 |
|---|---|
| Unique (%) | 19.4% |
| Missing | 4132 |
| Missing (%) | 30.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2363.2186711522286 |
|---|---|
| Minimum | 625.0 |
| Maximum | 15160.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 106.6 KiB |
Quantile statistics
| Minimum | 625 |
|---|---|
| 5-th percentile | 1207 |
| Q1 | 1720 |
| median | 2110 |
| Q3 | 2703 |
| 95-th percentile | 4045.7 |
| Maximum | 15160 |
| Range | 14535 |
| Interquartile range (IQR) | 983 |
Descriptive statistics
| Standard deviation | 1155.945331 |
|---|---|
| Coefficient of variation (CV) | 0.4891402328 |
| Kurtosis | 25.94459392 |
| Mean | 2363.218671 |
| Median Absolute Deviation (MAD) | 460 |
| Skewness | 3.825272383 |
| Sum | 22478936 |
| Variance | 1336209.608 |
| Value | Count | Frequency (%) | |
| 1350 | 63 | 0.5% | |
| 1695 | 52 | 0.4% | |
| 1895 | 47 | 0.3% | |
| 1899 | 47 | 0.3% | |
| 1900 | 46 | 0.3% | |
| 2250 | 45 | 0.3% | |
| 2095 | 40 | 0.3% | |
| 2000 | 40 | 0.3% | |
| 2700 | 39 | 0.3% | |
| 1850 | 39 | 0.3% | |
| Other values (1836) | 9054 | 66.4% | |
| (Missing) | 4132 | 30.3% |
| Value | Count | Frequency (%) | |
| 625 | 1 | < 0.1% | |
| 645 | 1 | < 0.1% | |
| 650 | 1 | < 0.1% | |
| 750 | 1 | < 0.1% | |
| 763 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 15160 | 4 | < 0.1% | |
| 14860 | 4 | < 0.1% | |
| 13160 | 4 | < 0.1% | |
| 12500 | 1 | < 0.1% | |
| 11660 | 4 | < 0.1% |
| Distinct count | 1524 |
|---|---|
| Unique (%) | 11.3% |
| Missing | 213 |
| Missing (%) | 1.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 747.04910282183 |
|---|---|
| Minimum | 90.0 |
| Maximum | 4380.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 106.6 KiB |
Quantile statistics
| Minimum | 90 |
|---|---|
| 5-th percentile | 317 |
| Q1 | 567 |
| median | 696 |
| Q3 | 904 |
| 95-th percentile | 1227 |
| Maximum | 4380 |
| Range | 4290 |
| Interquartile range (IQR) | 337 |
Descriptive statistics
| Standard deviation | 298.8450342 |
|---|---|
| Coefficient of variation (CV) | 0.4000339911 |
| Kurtosis | 6.579931398 |
| Mean | 747.0491028 |
| Median Absolute Deviation (MAD) | 164 |
| Skewness | 1.506451907 |
| Sum | 10033616.5 |
| Variance | 89308.35446 |
| Value | Count | Frequency (%) | |
| 600 | 104 | 0.8% | |
| 670 | 83 | 0.6% | |
| 1000 | 71 | 0.5% | |
| 589 | 70 | 0.5% | |
| 573 | 64 | 0.5% | |
| 633 | 59 | 0.4% | |
| 650 | 59 | 0.4% | |
| 656 | 57 | 0.4% | |
| 700 | 56 | 0.4% | |
| 665 | 55 | 0.4% | |
| Other values (1514) | 12753 | 93.5% | |
| (Missing) | 213 | 1.6% |
| Value | Count | Frequency (%) | |
| 90 | 2 | < 0.1% | |
| 145 | 10 | 0.1% | |
| 147 | 1 | < 0.1% | |
| 149 | 4 | < 0.1% | |
| 153 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 4380 | 1 | < 0.1% | |
| 3380 | 1 | < 0.1% | |
| 3000 | 2 | < 0.1% | |
| 2950 | 1 | < 0.1% | |
| 2720 | 1 | < 0.1% |
availability
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 13.3 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) | |
| False | 8028 | 58.8% | |
| True | 5616 | 41.2% |
| Distinct count | 70 |
|---|---|
| Unique (%) | 36.5% |
| Missing | 13452 |
| Missing (%) | 98.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1567.1510416666667 |
|---|---|
| Minimum | 100.0 |
| Maximum | 6700.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 106.6 KiB |
Quantile statistics
| Minimum | 100 |
|---|---|
| 5-th percentile | 400 |
| Q1 | 887.5 |
| median | 1287.5 |
| Q3 | 2000 |
| 95-th percentile | 3632.75 |
| Maximum | 6700 |
| Range | 6600 |
| Interquartile range (IQR) | 1112.5 |
Descriptive statistics
| Standard deviation | 1043.523759 |
|---|---|
| Coefficient of variation (CV) | 0.6658731235 |
| Kurtosis | 3.339982309 |
| Mean | 1567.151042 |
| Median Absolute Deviation (MAD) | 537.5 |
| Skewness | 1.550877642 |
| Sum | 300893 |
| Variance | 1088941.836 |
| Value | Count | Frequency (%) | |
| 1000 | 28 | 0.2% | |
| 1500 | 16 | 0.1% | |
| 500 | 11 | 0.1% | |
| 1200 | 9 | 0.1% | |
| 2000 | 8 | 0.1% | |
| 750 | 8 | 0.1% | |
| 800 | 7 | 0.1% | |
| 400 | 6 | < 0.1% | |
| 1400 | 5 | < 0.1% | |
| 350 | 4 | < 0.1% | |
| Other values (60) | 90 | 0.7% | |
| (Missing) | 13452 | 98.6% |
| Value | Count | Frequency (%) | |
| 100 | 1 | < 0.1% | |
| 250 | 1 | < 0.1% | |
| 300 | 1 | < 0.1% | |
| 350 | 4 | < 0.1% | |
| 400 | 6 | < 0.1% |
| Value | Count | Frequency (%) | |
| 6700 | 1 | < 0.1% | |
| 5000 | 1 | < 0.1% | |
| 4700 | 1 | < 0.1% | |
| 4400 | 2 | < 0.1% | |
| 4200 | 1 | < 0.1% |
| Distinct count | 1726 |
|---|---|
| Unique (%) | 38.1% |
| Missing | 9113 |
| Missing (%) | 66.8% |
| Memory size | 106.6 KiB |
| 406 | 39 |
|---|---|
| 306 | 28 |
| 509 | 26 |
| 304 | 25 |
| 302 | 25 |
| Other values (1721) |
| Value | Count | Frequency (%) | |
| 406 | 39 | 0.3% | |
| 306 | 28 | 0.2% | |
| 509 | 26 | 0.2% | |
| 304 | 25 | 0.2% | |
| 302 | 25 | 0.2% | |
| 301 | 23 | 0.2% | |
| 321 | 21 | 0.2% | |
| 207 | 21 | 0.2% | |
| 501 | 21 | 0.2% | |
| 311 | 21 | 0.2% | |
| Other values (1716) | 4281 | 31.4% | |
| (Missing) | 9113 | 66.8% |
Length
| Max length | 20 |
|---|---|
| Median length | 3 |
| Mean length | 3.250219877 |
| Min length | 1 |
| Distinct count | 4 |
|---|---|
| Unique (%) | 2.4% |
| Missing | 13480 |
| Missing (%) | 98.8% |
| Memory size | 106.6 KiB |
| 12 | |
|---|---|
| 6 | 9 |
| 1 | 7 |
| 3 | 3 |
| Value | Count | Frequency (%) | |
| 12 | 145 | 1.1% | |
| 6 | 9 | 0.1% | |
| 1 | 7 | 0.1% | |
| 3 | 3 | < 0.1% | |
| (Missing) | 13480 | 98.8% |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.010627382 |
| Min length | 3 |
| Distinct count | 4476 |
|---|---|
| Unique (%) | 33.6% |
| Missing | 335 |
| Missing (%) | 2.5% |
| Memory size | 106.6 KiB |
| Studio | 405 |
|---|---|
| A4 | 102 |
| 1 Bedroom | 101 |
| 1x1 | 99 |
| Standard Studio | 95 |
| Other values (4471) |
| Value | Count | Frequency (%) | |
| Studio | 405 | 3.0% | |
| A4 | 102 | 0.7% | |
| 1 Bedroom | 101 | 0.7% | |
| 1x1 | 99 | 0.7% | |
| Standard Studio | 95 | 0.7% | |
| A1 | 95 | 0.7% | |
| A2 | 92 | 0.7% | |
| 2x2 | 91 | 0.7% | |
| A3 | 70 | 0.5% | |
| S1 | 67 | 0.5% | |
| Other values (4466) | 12092 | 88.6% | |
| (Missing) | 335 | 2.5% |
Length
| Max length | 50 |
|---|---|
| Median length | 8 |
| Mean length | 9.647903841 |
| Min length | 1 |
| Distinct count | 1 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 13121 |
| Missing (%) | 96.2% |
| Memory size | 106.6 KiB |
| New |
|---|
| Value | Count | Frequency (%) | |
| New | 523 | 3.8% | |
| (Missing) | 13121 | 96.2% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| Unnamed: 0_x | propertyName | street | city | state | zipCode | neighborhood | reviewScore | reviewCount | walkScore | transitScore | Unnamed: 0_y | bedRoomType | bedRoomNumber | baths | rent | sqft | availability | deposit | unit | leaseLength | name | new | applyNow | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | Jackson Apartments | 2401 S Jackson St | Seattle | WA | 98144 | Atlantic | 0 | 0 | 90 | 70 | 0 | Studio | 1 | 1.0 | 1790.0 | 465.0 | True | NaN | NaN | NaN | S.2.W | NaN | NaN |
| 1 | 0 | Jackson Apartments | 2401 S Jackson St | Seattle | WA | 98144 | Atlantic | 0 | 0 | 90 | 70 | 1 | Studio | 1 | 1.0 | 1905.0 | 475.0 | True | NaN | NaN | NaN | S.1.E | NaN | NaN |
| 2 | 0 | Jackson Apartments | 2401 S Jackson St | Seattle | WA | 98144 | Atlantic | 0 | 0 | 90 | 70 | 2 | Studio | 1 | 1.0 | 1920.0 | 570.0 | True | NaN | NaN | NaN | S.3.S | NaN | NaN |
| 3 | 0 | Jackson Apartments | 2401 S Jackson St | Seattle | WA | 98144 | Atlantic | 0 | 0 | 90 | 70 | 3 | Traditional | 1 | 1.0 | 2060.0 | 509.0 | True | NaN | NaN | NaN | 0.18.W | NaN | NaN |
| 4 | 0 | Jackson Apartments | 2401 S Jackson St | Seattle | WA | 98144 | Atlantic | 0 | 0 | 90 | 70 | 4 | Traditional | 1 | 1.0 | 2070.0 | 657.0 | True | NaN | NaN | NaN | 0.17.W | NaN | NaN |
| 5 | 0 | Jackson Apartments | 2401 S Jackson St | Seattle | WA | 98144 | Atlantic | 0 | 0 | 90 | 70 | 5 | Traditional | 1 | 1.0 | 2075.0 | 596.0 | True | NaN | NaN | NaN | 0.4.E | NaN | NaN |
| 6 | 0 | Jackson Apartments | 2401 S Jackson St | Seattle | WA | 98144 | Atlantic | 0 | 0 | 90 | 70 | 6 | Traditional | 1 | 1.0 | 2075.0 | 597.0 | True | NaN | NaN | NaN | 0.1.2 | NaN | NaN |
| 7 | 0 | Jackson Apartments | 2401 S Jackson St | Seattle | WA | 98144 | Atlantic | 0 | 0 | 90 | 70 | 7 | Traditional | 1 | 1.0 | 2075.0 | 598.0 | True | NaN | NaN | NaN | 0.6.W | NaN | NaN |
| 8 | 0 | Jackson Apartments | 2401 S Jackson St | Seattle | WA | 98144 | Atlantic | 0 | 0 | 90 | 70 | 8 | Traditional | 1 | 1.0 | 2075.0 | 620.0 | True | NaN | NaN | NaN | 0.9.W | NaN | NaN |
| 9 | 0 | Jackson Apartments | 2401 S Jackson St | Seattle | WA | 98144 | Atlantic | 0 | 0 | 90 | 70 | 9 | Traditional | 1 | 1.0 | 2075.0 | 629.0 | True | NaN | NaN | NaN | 0.20.S | NaN | NaN |
Last rows
| Unnamed: 0_x | propertyName | street | city | state | zipCode | neighborhood | reviewScore | reviewCount | walkScore | transitScore | Unnamed: 0_y | bedRoomType | bedRoomNumber | baths | rent | sqft | availability | deposit | unit | leaseLength | name | new | applyNow | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13634 | 726 | 3 br, 1 bath House - 8533 18th Ave NW | 8533 18th Ave NW | Seattle | WA | 98117 | Crown Hill | 0 | 0 | 85 | 54 | 10506 | Traditional | 3 | 1.0 | 3600.0 | 1550.0 | True | NaN | NaN | NaN | NaN | NaN | NaN |
| 13635 | 727 | 1320 14th Ave S | 1320 14th Ave S | Seattle | WA | 98144 | Seattle | 0 | 0 | 74 | 89 | 10507 | Traditional | 2 | 1.0 | 1695.0 | 750.0 | True | NaN | NaN | NaN | NaN | NaN | Request To Apply |
| 13636 | 729 | 10306 Holman Rd N | 10306 Holman Rd N | Seattle | WA | 98133 | Greenwood | 0 | 0 | 85 | 57 | 10517 | Studio | 1 | 1.0 | 1100.0 | 400.0 | True | NaN | NaN | NaN | NaN | NaN | Request To Apply |
| 13637 | 730 | 311 6th Ave S | 311 6th Ave S | Seattle | WA | 98104 | Chinatown | 0 | 0 | 99 | 100 | 10518 | Studio | 1 | 1.0 | 1195.0 | 386.0 | True | NaN | NaN | NaN | NaN | NaN | Request To Apply |
| 13638 | 731 | 1307 N Northgate Way | 1307 N Northgate Way | Seattle | WA | 98133 | North College Park | 0 | 0 | 87 | 61 | 10519 | Studio | 1 | 1.0 | 1295.0 | 288.0 | True | NaN | NaN | NaN | NaN | NaN | Request To Apply |
| 13639 | 732 | 3631 13th Ave W | 3631 13th Ave W | Seattle | WA | 98119 | Queen Anne | 0 | 0 | 69 | 56 | 10520 | Traditional | 2 | 1.0 | 1600.0 | 900.0 | True | NaN | NaN | NaN | NaN | NaN | Request To Apply |
| 13640 | 733 | 500 W Mercer St | 500 W Mercer St | Seattle | WA | 98119 | Lower Queen Anne | 0 | 0 | 84 | 63 | 10521 | Traditional | 2 | 1.0 | 2400.0 | 1180.0 | True | NaN | NaN | NaN | NaN | NaN | Request To Apply |
| 13641 | 735 | 6 br, 3 bath House - 12705 27th Ave NE | 12705 27th Ave NE | Seattle | WA | 98125 | Lake City | 0 | 0 | 88 | 60 | 10632 | Traditional | 6 | 3.0 | 3150.0 | 2400.0 | True | NaN | NaN | NaN | NaN | NaN | NaN |
| 13642 | 736 | 3230 SW Avalon Way | 3230 SW Avalon Way | Seattle | WA | 98126 | Fairmount Park | 0 | 0 | 78 | 58 | 10633 | Traditional | 1 | 1.0 | 1395.0 | 605.0 | True | NaN | NaN | NaN | NaN | NaN | Request To Apply |
| 13643 | 737 | 7719 Renton Ave S | 7719 Renton Ave S | Seattle | WA | 98118 | Brighton | 0 | 0 | 76 | 64 | 10634 | Traditional | 2 | 1.0 | 1725.0 | 780.0 | True | NaN | NaN | NaN | NaN | NaN | NaN |